Stored Procedures [dbo].[BAEActivityTypeGetFundraising]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEActivityTypeGetFundraising
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
SQL Script
/*
* Gets the Activity Types only for Fundraising
*
* PURPOSE:    In case the activity types change for fundraising, it would be
*            easier to change in a stored procedure rather in code.
*/


CREATE procedure [dbo].[BAEActivityTypeGetFundraising]
AS
SELECT DISTINCT ACTIVITY_TYPE
FROM Activity
WHERE ACTIVITY_TYPE = 'PLEDGE' OR ACTIVITY_TYPE = 'GIFT'
ORDER BY ACTIVITY_TYPE ASC;

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved